So much much earlier and said this course we talked about a feature called subtotals where we were able
to create a subtotal based on some column of data such as maybe what you're looking at in front of you
to get a subtotal and total expense based on a group within the data set.
So I could do something like Hey I want to get a subtotal for total expense based on division.
So I want to get a subtotal for Easts total expense get a subtotal for North.
Total expense and so on.
This was a part of the sub total tool.
Now we saw just really briefly that there was an extra feature that came with the subtotal tool and
it was called Group an outline.
It allowed you to collapse or expand your subtotals.
Now what I want to show you here is how you can create your own group and outlines how you can group
rows or columns inside of larger worksheets such as what you're looking at here.
So once again I'm back inside of the Excel one or two exercise files folder and I'm inside the list
functions worksheet.
Now what I'd like to do here is we got some months January February and March months worth of data here
for these different divisions and different categories.
Well you know what I don't need to see all of these months all of the time.
I want to build the hide just temporarily hide some of these columns when I don't need to see them.
Now you could you could always do this.
I want to hi Jan. So I can Slyke column C I could right click and I can choose hide up when I need to
get it back.
I can then unhide it and I can hide February and I can unhide it and I can hide margined unhide it and
so on.
But it's a very manual process it's not very accessible when I'm going to show you here is going to
create a little interface that you can expand and collapse at any point.
Watch this.
So say I want to hide January temporarily so I'm in a slight column C just give that a click I'll go
up to my data tab the top of the screen on the far right you've got a section called outline.
And then there I get group.
I'm going to go to group and I'm going to go ahead group it.
So I've now created this group and this is little horizontal line at the top with this little button
on the far right.
If I get that a quick you know group of January essentially Heidi in the January column.
If I hit the plus sign it will expand it back out.
Now you know what will keep this going.
Right now I'm just due in January.
But let's say you know what I don't want to see January or February.
Well all highlights C and D.
I'll go right back to data right back to groove and I'm in a group it so I've got to know if I claps
the first one I hide January I open that back up.
Now Januarys back if I click on the second one I now hide.
January and February.
Well that was straight A third time.
I'm going to grab C D and E.
So January February March right back to data right back at the group and I now got a third one.
I can collapse individual January January February or January February and March are now hidden just
through a simple little interface called Group an outline.
And again you can always hide and un- hide but that's a very manual process.
Now it's just an interface that users can go to and click on buttons.
Try this out.
Open up the exercise file group them months or maybe take it a step further.
Try grouping the different divisions to highlight the rows.
Like I mean to get all the east right here to through 15 get those highlighted go right back to data
back to group and alt group.
So I've now created a group for each site and if I click on the number one up here I'll claps East.
Now I just got north up there.
Hit it again and there is east.
So interactive show in high feature called Group an ally trying out